Object Oriented Applicat…isualAge for C++ for OS/2/Object-Oriented Application Development with VisualAGE for C++ for OS2.iso/list.tab

Text File | 1996-02-19 | 20KB | 555 lines

 CREATE TABLE USERID.BUYER
      (BUYER_ID CHAR(11) NOT NULL,
       FIRST_NAME CHAR(20) NOT NULL,
       LAST_NAME CHAR(20) NOT NULL,
       MARRITAL_STATUS CHAR(1),
       GENDER CHAR(1),
       INCOME DECIMAL(15,2),
       WORK_PHONE CHAR(12),
       HOME_PHONE CHAR(12),
       PRIMARY KEY (BUYER_ID));

 CREATE TABLE USERID.BUYER_ADDRESS
      (ADDRESS_ID CHAR(11) NOT NULL,
       STREET CHAR(40) NOT NULL,
       AREA CHAR(40) NOT NULL,
       CITY CHAR(40) NOT NULL,
       STATE CHAR(2),
       ZIP_CODE CHAR(5) FOR BIT DATA,
       PRIMARY KEY ( ADDRESS_ID ));

 CREATE TABLE USERID.BUYER_LOG
       (BUYER_ID CHAR(11) NOT NULL,
        CREATION_TIMESTAMP TIMESTAMP,
        LAST_UPDATE TIMESTAMP,
        PRIMARY KEY ( BUYER_ID ));

 CREATE TABLE USERID.MARKETING_INFO
       (PROPERTY_ID CHAR(5) NOT NULL,
        PRICE DECIMAL(7,0) NOT NULL,
        DAYS_ON_MARKET SMALLINT,
        COMMISSION_RATE DECIMAL(5,2),
        DOWN_PAYMENT_RATE DECIMAL(5,2),
        PRIMARY KEY ( PROPERTY_ID ));

 CREATE TABLE USERID.MULTIDOC
       (MULTIDOC_ID CHAR(5) NOT NULL,
        FILENAME VARCHAR(254) NOT NULL,
        TYPE CHAR(20) NOT NULL,
        PRIMARY KEY (MULTIDOC_ID));

 CREATE TABLE USERID.PREFERENCE
       (BUYER_ID CHAR(11) NOT NULL,
        MAX_PRICE DECIMAL(15,2),
        MIN_PRICE DECIMAL(15,2),
        MAX_SIZE DECIMAL(15,2),
        MIN_SIZE DECIMAL(15,2),
        BEDROOMS SMALLINT,
        BATHROOMS SMALLINT,
        STORIES SMALLINT,
        HEATING CHAR(30),
        COOLING CHAR(30),
        PRIMARY KEY (BUYER_ID));

 CREATE TABLE USERID.PROPERTY
       (PROPERTY_ID CHAR(5) NOT NULL,
        SIZE DECIMAL(5,0) NOT NULL,
        BEDROOMS SMALLINT NOT NULL,
        BATHROOMS SMALLINT NOT NULL,
        STORIES SMALLINT NOT NULL,
        COOLING CHAR(30) NOT NULL,
        HEATING CHAR(30) NOT NULL,
        DESCRIPTION VARCHAR(512),
        PRIMARY KEY (PROPERTY_ID));

 CREATE TABLE USERID.PROPERTY_ADDRESS
       (ADDRESS_ID CHAR(5) NOT NULL,
        STREET CHAR(40) NOT NULL,
        AREA CHAR(40),
        CITY CHAR(40) NOT NULL,
        STATE CHAR(2),
        ZIP_CODE CHAR(5) FOR BIT DATA,
        PRIMARY KEY (ADDRESS_ID));

 CREATE TABLE USERID.PROPERTY_LOG
       (PROPERTY_ID CHAR(5) NOT NULL,
        DOWNLOAD_TIMESTAMP TIMESTAMP NOT NULL,
        LAST_UPDATE TIMESTAMP NOT NULL,
        STATUS CHAR(15) NOT NULL,
        PRIMARY KEY (PROPERTY_ID));

 CREATE TABLE USERID.SALE_TRANSACTION
       (TRANSACTION_ID TIMESTAMP NOT NULL,
        LAST_UPDATE TIMESTAMP NOT NULL,
        AGREEMENT_FORM_ID INTEGER NOT NULL,
        STATUS CHAR(10) NOT NULL,
        BUYER_ID CHAR(11) NOT NULL,
        PROPERTY_ID CHAR(5) NOT NULL,
        PRIMARY KEY (TRANSACTION_ID));

 CREATE VIEW USERID.BUYER_INFO
       (BUYER_ID,
        FIRST_NAME,
        LAST_NAME,
        INCOME,
        WORK_PHONE,
        HOME_PHONE,
        STREET,
        AREA,
        CITY,
        STATE,
        ZIP_CODE,
        MAX_PRICE,
        MIN_PRICE,
        MAX_SIZE,
        MIN_SIZE,
        BEDROOMS,
        BATHROOMS,
        STORIES,
        HEATING,
        COOLING)
        AS SELECT A.BUYER_ID,
                  FIRST_NAME,
                  LAST_NAME,
                  INCOME,
                  WORK_PHONE,
                  HOME_PHONE,
                  STREET,
                  AREA,
                  CITY,
                  STATE,
                  ZIP_CODE,
                  MAX_PRICE,
                  MIN_PRICE,
                  MAX_SIZE,
                  MIN_SIZE,
                  BEDROOMS,
                  BATHROOMS,
                  STORIES,
                  HEATING,
                  COOLING
                  FROM USERID.BUYER A,
                  USERID.BUYER_ADDRESS B,
                  USERID.PREFERENCE C
                  WHERE (A.BUYER_ID=ADDRESS_ID
                         AND A.BUYER_ID=C.BUYER_ID);

 CREATE VIEW USERID.PROP_AD_LOG
       (PROPERTY_ID,
        SIZE,
        BEDROOMS,
        BATHROOMS,
        AREA,
        CITY,
        STATE,
        STATUS,
        PRICE,
        COMMISSION_RATE,
        DOWN_PAYMENT_RATE)
        AS SELECT A.PROPERTY_ID,
                  SIZE,
                  BEDROOMS,
                  BATHROOMS,
                  AREA,
                  CITY,
                  STATE,
                  STATUS,
                  PRICE,
                  COMMISSION_RATE,
                  DOWN_PAYMENT_RATE
                  FROM USERID.PROPERTY A,
                       USERID.PROPERTY_ADDRESS B,
                       USERID.PROPERTY_LOG C,
                       USERID.MARKETING_INFO D
                  WHERE (A.PROPERTY_ID=ADDRESS_ID AND
                         A.PROPERTY_ID=C.PROPERTY_ID AND
                         A.PROPERTY_ID=D.PROPERTY_ID);

 CREATE VIEW USERID.LIST_AREA
       (AREA)
        AS SELECT DISTINCT AREA
                  FROM USERID.PROPERTY_ADDRESS A,
                       USERID.PROPERTY_LOG B
                  WHERE (ADDRESS_ID=PROPERTY_ID) AND
                        ((STATUS='AVAILABLE'));

 INSERT INTO BUYER VALUES('612-45-6798',
                          'Marc',
                          'Carrel',
                          'M',
                          'M',
                          5000,
                          '408-448-4088',
                          '408-927-5678');

 INSERT INTO BUYER VALUES('412-67-8856',
                          'Isabelle',
                          'Mauny',
                          'S',
                          'F',
                          4000,
                          '408-555-6789',
                          '408-927-1238');

 INSERT INTO BUYER VALUES('567-56-1234',
                          'Peter',
                          'Jakab',
                          'M',
                          'M',
                          7000,
                          '445-678-3422',
                          '434-927-5811');

 INSERT INTO BUYER VALUES('123-44-7823',
                          'Rainer',
                          'Vetter',
                          'M',
                          'M',
                          8000,
                          '456-467-6666',
                          '445-927-2345');

 INSERT INTO BUYER VALUES('345-55-1111',
                          'Paulette',
                          'Sopper',
                          'F',
                          'M',
                          5000,
                          '445-423-4333',
                          '456-927-9876');

 INSERT INTO BUYER VALUES('678-22-1118',
                          'Guido',
                          'De Simoni',
                          'M',
                          'S',
                          5000,
                          '408-448-2348',
                          '466-927-1234');

 INSERT INTO BUYER_ADDRESS VALUES('612-45-6798',
                                  '1089 Normington Way',
                                  'Almaden',
                                  'San Jose',
                                  'CA',
                                  '95136' );

 INSERT INTO BUYER_ADDRESS VALUES('412-67-8856',
                                  '1234 Blossom Hill Road',
                                  'Tenessee',
                                  'Morgan Hill',
                                  'CA',
                                  '95136' );

 INSERT INTO BUYER_ADDRESS VALUES('567-56-1234',
                                  '12 Harry Road',
                                  'Tropico',
                                  'Los Gatos',
                                  'CA',
                                  '95136');

 INSERT INTO BUYER_ADDRESS VALUES('123-44-7823',
                                  '134 Onmy Way',
                                  'New Island',
                                  'Saratoga',
                                  'CA',
                                  '95136' );

 INSERT INTO BUYER_ADDRESS VALUES('345-55-1111',
                                  '456 Quiche Way',
                                  'Castro',
                                  'San Francisco',
                                  'CA',
                                  '95136' );

 INSERT INTO BUYER_ADDRESS VALUES('678-22-1118',
                                  '789 5th Avenue',
                                  'Cherry Trees',
                                  'New York',
                                  'NY',
                                  '95136' );

 INSERT INTO PREFERENCE VALUES('612-45-6798',
                               3000,
                               2000,
                               300,
                               200,
                               2,
                               4,
                               1,
                               'No Heating',
                               'No Cooling');

 INSERT INTO PREFERENCE VALUES('412-67-8856',
                               4000,
                               3000,
                               400,
                               300,
                               2,
                               3,
                               2,
                               'Gas',
                               'No Cooling');

 INSERT INTO PREFERENCE VALUES('567-56-1234',
                               5000,
                               4000,
                               500,
                               400,
                               3,
                               2,
                               2,
                               'Electric',
                               'Room Air Conditioner');

 INSERT INTO PREFERENCE VALUES('123-44-7823',
                               6000,
                               5000,
                               600,
                               500,
                               1,
                               1,
                               3,
                               'Propane Gas',
                               'Evaporative Cooler');

 INSERT INTO PREFERENCE VALUES('345-55-1111',
                               7000,
                               6000,
                               700,
                               600,
                               1,
                               3,
                               2,
                               'Solar',
                               'No Cooling');

 INSERT INTO PREFERENCE VALUES('678-22-1118',
                               8000,
                               7000,
                               800,
                               700,
                               5,
                               4,
                               1,
                               'Oil',
                               'Evaporative Cooler');

 INSERT INTO BUYER_LOG VALUES('612-45-6798',
                              '1995-12-04-12.12.12.000000',
                              '1995-12-04-12.12.12.000000');

 INSERT INTO BUYER_LOG VALUES('412-67-8856',
                              '1995-12-04-12.12.12.000000',
                              '1995-12-04-12.12.12.000000');

 INSERT INTO BUYER_LOG VALUES('567-56-1234',
                              '1995-12-04-12.12.12.000000',
                              '1995-12-04-12.12.12.000000');

 INSERT INTO BUYER_LOG VALUES('123-44-7823',
                              '1995-12-04-12.12.12.000000',
                              '1995-12-04-12.12.12.000000');

 INSERT INTO BUYER_LOG VALUES('345-55-1111',
                              '1995-12-04-12.12.12.000000',
                              '1995-12-04-12.12.12.000000');

 INSERT INTO BUYER_LOG VALUES('678-22-1118',
                              '1995-12-04-12.12.12.000000',
                              '1995-12-04-12.12.12.000000');

 INSERT INTO PROPERTY VALUES('11111',
                             800,
                             10,
                             5,
                             3,
                             'No Heating',
                             'No Cooling',
                             'Big House with all the
                             facilities. Garden a la Francaise.' );

 INSERT INTO PROPERTY VALUES('22222',
                             700,
                             5,
                             3,
                             2,
                             'Gas',
                             'No Cooling',
                             'Two little houses with dependencies.
                             Backyard and swimming pool.' );

 INSERT INTO PROPERTY VALUES('33333',
                             600,
                             4,
                             2,
                             2,
                             'Electric',
                             'Evaporative Cooler',
                             'Painting gallery. completely
                             remodeled. Great for exhibition.' );

 INSERT INTO PROPERTY VALUES('44444',
                             500,
                             3,
                             2,
                             1,
                             'Propane Gas',
                             'Room Air Conditioner',
                             'The "Versailles" of the area.
                             Many fountains a springs.
                             Nice for showing off' );

 INSERT INTO PROPERTY VALUES('55555',
                             400,
                             2,
                             1,
                             1,
                             'Solar',
                             'Evaportative Cooler',
                             'Clean and simple.
                             But very affordable' );

 INSERT INTO PROPERTY VALUES('66666',
                             300,
                             1,
                             1,
                             1,
                             'Oil',
                             'No Cooling',
                             'A best deal in
                             this range of price!');

 INSERT INTO PROPERTY_ADDRESS VALUES('11111',
                                     '1089 Normington Way',
                                     'Almaden',
                                     'San Jose',
                                     'CA',
                                     '95136' );

 INSERT INTO PROPERTY_ADDRESS VALUES('22222',
                                     '1234 Blossom Hill Road',
                                     'Tenessee',
                                     'Morgan Hill',
                                     'CA',
                                     '95136' );

 INSERT INTO PROPERTY_ADDRESS VALUES('33333',
                                     '12 Harry Road',
                                     'Tropico',
                                     'Los Gatos',
                                     'CA',
                                     '95136' );

 INSERT INTO PROPERTY_ADDRESS VALUES('44444',
                                     '134 Onmy Way',
                                     'New Island',
                                     'Saratoga',
                                     'CA',
                                     '95136' );

 INSERT INTO PROPERTY_ADDRESS VALUES('55555',
                                     '456 Quiche Way',
                                     'Castro',
                                     'San Francisco',
                                     'CA',
                                     '95136' );

 INSERT INTO PROPERTY_ADDRESS VALUES('66666',
                                     '789 5th Avenue',
                                     'Cherry Trees',
                                     'New York',
                                     'NY',
                                     '95136' );

 INSERT INTO MARKETING_INFO VALUES('11111',
                                   5672000,
                                   5,
                                   5.25,
                                   5.5);

 INSERT INTO MARKETING_INFO VALUES('22222',
                                   123000,
                                   4,
                                   8.40,
                                   10.0);

 INSERT INTO MARKETING_INFO VALUES('33333',
                                   500000,
                                   9,
                                   2.5,
                                   6.5);

 INSERT INTO MARKETING_INFO VALUES('44444',
                                   1000000,
                                   1,
                                   1.4,
                                   3.5);

 INSERT INTO MARKETING_INFO VALUES('55555',
                                   679000,
                                   2,
                                   5.75,
                                   5.3);

 INSERT INTO MARKETING_INFO VALUES('66666',
                                   1200000,
                                   6,
                                   1.25,
                                   4.5);

 INSERT INTO PROPERTY_LOG VALUES('11111',
                                 '1995-12-30-17.01.35.00000',
                                 '1996-01-06-15.11.32.00000',
                                 'AVAILABLE' );

 INSERT INTO PROPERTY_LOG VALUES('22222',
                                 '1995-12-30-17.01.35.00000',
                                 '1996-01-06-15.11.32.00000',
                                 'AVAILABLE' );

 INSERT INTO PROPERTY_LOG VALUES('33333',
                                 '1995-12-30-17.01.35.00000',
                                 '1996-01-06-15.11.32.00000',
                                 'AVAILABLE' );

 INSERT INTO PROPERTY_LOG VALUES('44444',
                                 '1995-12-30-17.01.35.00000',
                                 '1996-01-06-15.11.32.00000',
                                 'AVAILABLE' );

 INSERT INTO PROPERTY_LOG VALUES('55555',
                                 '1995-12-30-17.01.35.00000',
                                 '1996-01-06-15.11.32.00000',
                                 'AVAILABLE' );

 INSERT INTO PROPERTY_LOG VALUES('66666',
                                 '1995-12-30-17.01.35.00000',
                                 '1996-01-06-15.11.32.00000',
                                 'AVAILABLE' );

 INSERT INTO MULTIDOC VALUES('11111',
                             '',
                             'VIDEO' );

 INSERT INTO MULTIDOC VALUES('22222',
                             '',
                             'VIDEO' );

 INSERT INTO MULTIDOC VALUES('33333',
                             '',
                             'VIDEO' );

 INSERT INTO MULTIDOC VALUES('44444',
                             '',
                             'VIDEO' );

 INSERT INTO MULTIDOC VALUES('55555',
                             '',
                             'VIDEO' );

 INSERT INTO MULTIDOC VALUES('66666',
                             '',
                             'VIDEO' );